Notes/Domino 6 and 7 Forum : RE: Can @For and @While works on Web?

Notes/Domino 6 and 7 Forum

RE: Can @For and @While works on Web?

RE: Can @For and @While works on Web?
Posted by ~Sven Kifoogenli on 19.Dec.03 at 03:25 PM using a Web browser
Category: Domino Designer

Release: 6.0.2 CF2

Platform: Windows 2000

Yes it can, but it works in the same way as an @If or any other formula, so if you want to perform more than one function you need to nest the functions in an @Do statement,as below. Also it's a good idea to use [FailSilent] for @DBLookups in ND6 so you don't have to check for potential errors. Also, is the day field you're trying to set a number field?

@For(n:= 1;n <= @Elements(AllStaff);n:= n + 1;
@Do(@SetField("Leave" + @Text(n);AllStaff[n]);
xKey:=@Text(@Year(@Today)) + Applicant + AllStaff[n];
Tkn_process:=@DbLookup("Notes":"NoCache"; @DbName;"WLS";xKey;"NoOfDay";[FailSilent]);
Tot:=@If(@IsError(@Sum(Tkn_process));0;@Sum(Tkn_process));
@SetField("Day" + @Text(n);Tot)))

Hope that works - it can be a bit fiddly sometimes...